package com.hserver.docker.config;

/**
 * @author hxm
 */
public class InitSqlConfig {
    public static final String SQLS[]=new String[]{
      "PRAGMA foreign_keys = false;",
            "CREATE TABLE \"deploy\" (\n" +
                    "  \"uuid\" text NOT NULL,\n" +
                    "  \"name\" TEXT,\n" +
                    "  \"user_name\" TEXT,\n" +
                    "  \"password\" TEXT,\n" +
                    "  \"docker_file_name\" TEXT,\n" +
                    "  \"docker_file_path\" TEXT,\n" +
                    "  \"image_tag\" TEXT,\n" +
                    "  \"container_id\" TEXT,\n" +
                    "  \"ports\" TEXT,\n" +
                    "  \"volume\" TEXT,\n" +
                    "  \"url\" TEXT,\n" +
                    "  \"branch\" TEXT,\n" +
                    "  PRIMARY KEY (\"uuid\")\n" +
                    ");",
            "PRAGMA foreign_keys = true;",

            "PRAGMA foreign_keys = false;",
            "CREATE TABLE \"record\" (\n" +
                    "  \"id\" text NOT NULL,\n" +
                    "  \"uuid\" text NOT NULL,\n" +
                    "  \"image_id\" TEXT,\n" +
                    "  \"status\" TEXT,\n" +
                    "  \"start_time\" Integer,\n" +
                    "  \"end_time\" Integer,\n" +
                    "  PRIMARY KEY (\"id\")\n" +
                    ");",
            "PRAGMA foreign_keys = true;",
    };

}
